[dbo].[EventRegistrant]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:20 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_EventRegistrant: RegistrantID\EventCode$	RegistrantID	varchar(10)	10
$Cluster Primary Key PK_EventRegistrant: RegistrantID\EventCode$	EventCode	varchar(15)	15
$Indexes iWC: UserID\RegistrantClass\LastName\Email$	UserID	varchar(60)	60
	SessionStartDate	datetime	8
$Indexes iWC: UserID\RegistrantClass\LastName\Email$	RegistrantClass	varchar(5)	5
	FirstName	varchar(20)	20
	MiddleInitial	varchar(20)	20
$Indexes iWC: UserID\RegistrantClass\LastName\Email$	LastName	varchar(30)	30
	Address1	varchar(40)	40
	Address2	varchar(40)	40
	Address3	varchar(40)	40
	City	varchar(40)	40
	StateProvince	varchar(15)	15
	PostalCode	varchar(10)	10
	ApplyPermanentChanges	bit	1
	AddressPurpose	varchar(20)	20
	Phone	varchar(25)	25
$Indexes iWC: UserID\RegistrantClass\LastName\Email$	Email	varchar(100)	100
	Country	varchar(25)	25

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_EventRegistrant: RegistrantID\EventCode$

RegistrantID

varchar(10)

$Cluster Primary Key PK_EventRegistrant: RegistrantID\EventCode$

EventCode

varchar(15)

$Indexes iWC: UserID\RegistrantClass\LastName\Email$

UserID

varchar(60)

SessionStartDate

datetime

$Indexes iWC: UserID\RegistrantClass\LastName\Email$

RegistrantClass

varchar(5)

FirstName

varchar(20)

MiddleInitial

varchar(20)

$Indexes iWC: UserID\RegistrantClass\LastName\Email$

LastName

varchar(30)

Address1

varchar(40)

Address2

varchar(40)

Address3

varchar(40)

City

varchar(40)

StateProvince

varchar(15)

PostalCode

varchar(10)

ApplyPermanentChanges

bit

AddressPurpose

varchar(20)

Phone

varchar(25)

$Indexes iWC: UserID\RegistrantClass\LastName\Email$

varchar(100)

100

Country

varchar(25)

	Name	Columns	Unique
$Cluster Primary Key PK_EventRegistrant: RegistrantID\EventCode$	PK_EventRegistrant	RegistrantID, EventCode
	iWC	UserID, RegistrantClass, LastName, Email

Name

Columns

Unique

$Cluster Primary Key PK_EventRegistrant: RegistrantID\EventCode$

PK_EventRegistrant

RegistrantID, EventCode

iWC

UserID, RegistrantClass, LastName, Email

SQL Script

CREATE TABLE [dbo].[EventRegistrant]
(
[RegistrantID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserID] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SessionStartDate] [datetime] NULL,
[RegistrantClass] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiddleInitial] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateProvince] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApplyPermanentChanges] [bit] NULL,
[AddressPurpose] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Phone] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventRegistrant] ADD CONSTRAINT [PK_EventRegistrant] PRIMARY KEY CLUSTERED ([RegistrantID], [EventCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[EventRegistrant] ([UserID], [RegistrantClass], [LastName], [Email]) ON [PRIMARY]
GO